package ylsb.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import ylsb.model.Yiyonghaocai;
import ylsb.model.YiyonghaocaiExample;

public interface YiyonghaocaiMapper {

    List<Map<String, Object>> findPinzhongAll(@Param("xiangmuid") String ppxiangmuId, @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    List<Map<String, Object>> findPinpaiByPinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao") String ppPinzhongOne);

    List<Map<String, Object>> findPinpaiFenlei(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhongOne);



    List<Map<String, Object>> findXinghaoByPinpai(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhongOne,@Param("pinpaixuhao")String ppPinpaiOne);

    Object getYiyonghaocailist(@Param("xiangmuid") String ppxiangmuId,@Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    List<Map<String, Object>> findPinpaiResultByPinzhong(@Param("xiangmuid")String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")String ppPinzhongOne);

    List<Map<String, Object>> findPinzhongAndPinpaiByXiangmuId(@Param("xiangmuid") String mmxiangmuId);

    List<Map<String, Object>> findDaochuPinzhongAll(@Param("xiangmuid") String ppxiangmuId);

    List<Map<String, Object>> findResultGuochanBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("userid")String ppuserId,@Param("pinzhongxuhao")String ppPinzhong);

    List<Map<String, Object>> findZuanjiBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhong,@Param("pinpaixuhao")String ppPinpai);

    List<Map<String, Object>> findGuochanBypinzhong(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhong);

    List<Map<String, Object>> findGuochanBypinzhongAndpinpai(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhong,@Param("pinpaixuhao")String ppPinpa);

    List<Map<String, Object>> findyibaoBypinzhongAndpinpai(@Param("xiangmuid") String ppxiangmuId,@Param("pinzhongxuhao")String ppPinzhong,@Param("pinpaixuhao")String ppPinpai);

    List<Map<String, Object>> findXinghaoJieguoByPinpai(@Param("pinzhongxuhao")String ppPinzhongOne,@Param("pinpaixuhao")String ppPinpaiOne,@Param("xiangmuid")String ppxiangmuId,@Param("userid")String ppuserId);

    int countByExample(YiyonghaocaiExample example);

    int deleteByExample(YiyonghaocaiExample example);

    Yiyonghaocai selectByPrimaryKey(String id);

    int insert(Yiyonghaocai record);

    int insertSelective(Yiyonghaocai record);

    List<Yiyonghaocai> selectByExample(YiyonghaocaiExample example);

    int updateByExampleSelective(@Param("record") Yiyonghaocai record, @Param("example") YiyonghaocaiExample example);

    int updateByExample(@Param("record") Yiyonghaocai record, @Param("example") YiyonghaocaiExample example);
}